package cn.net.shuxing.yifu.common.mapper;

import cn.net.shuxing.yifu.common.bean.CoinType;
import cn.net.shuxing.yifu.common.bean.Country;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

public interface CountryMapper extends Mapper<Country> {
    @Select("SELECT id,country_name,country_num,country_name_english,deleted,create_time,update_time FROM country WHERE deleted = 0 and (country_name like #{name} or country_name_english like #{name})")
    public List<Country> getCountryList(@Param("name") String name);
}
